﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

IF NOT EXISTS (SELECT * FROM [dbo].[purchase_Status] WHERE [StatusId] = 1)
BEGIN
	INSERT [dbo].[purchase_Status] ([StatusId], [Description]) 
	VALUES (1, N'Purchased')
END

IF NOT EXISTS (SELECT * FROM [dbo].[purchase_Status] WHERE [StatusId] = 2)
BEGIN
	INSERT [dbo].[purchase_Status] ([StatusId], [Description]) 
	VALUES (2, N'Refund')
END

IF NOT EXISTS (SELECT * FROM [dbo].[purchase_Status] WHERE [StatusId] = 3)
BEGIN
	INSERT [dbo].[purchase_Status] ([StatusId], [Description]) 
	VALUES (3, N'Gift')
END